
*********************************************
****   Description   ************************
*********************************************

* This program summarizes the list of newspapers used in the advertising analysis, and the count of articles in each, generating "Table 1. Bank Advertisement Dataset - Summary Statistics." 

*********************************************
****   Summary Statistics *******************
*********************************************

use "$Data/AdvertisingSource_AllArticles_December2024.dta", clear


 
*********************************************
****   Newspapers Articles*******************
*********************************************


preserve
gen n=1
collapse (sum) n (mean) issues_screened, by(Newspaper State Frequency coverage Readership)
gsort -n
listtex Newspaper State Frequency coverage issues_screened  n if Readership=="African American", type rstyle(tabular)

listtex Newspaper State Frequency coverage  issues_screened n if Readership=="General Audience", type rstyle(tabular)
restore

 
 
*********************************************
****   Newspapers across Banks*************** 
*********************************************
preserve
keep if Bank=="FSB"
gen n=1
collapse (sum) n, by(Newspaper State Frequency coverage Readership)
gsort -n
listtex Newspaper State Frequency coverage  n if Readership=="African American", type rstyle(tabular)

listtex Newspaper State Frequency coverage  n if Readership=="General Audience", type rstyle(tabular)
restore

 
 

preserve
keep if Bank!="FSB"
gen n=1
collapse (sum) n, by(Newspaper State Frequency coverage Readership)
gsort -n
listtex Newspaper State Frequency coverage  n if Readership=="African American", type rstyle(tabular)

listtex Newspaper State Frequency coverage  n if Readership=="General Audience", type rstyle(tabular)
restore

